create external table jms_dm.dm_center_sort_ass_detail_hi
(
	 waybill_no       string comment'运单号'
	,network_code     string comment'网点编码'
	,network_name     string comment'网点名称'
	,scan_time        timestamp comment'扫描时间'
	,agency_area_name string comment'代理商名称'
	,agency_area_code string comment'代理商编码'
	,franchisee_name  string comment'加盟商名称'
	,franchisee_code  string comment'加盟商编码'
	,grid_code        string comment'格口编码/异常编码'
	,owned_venue_type string comment'场地属性'
	,equipment_code   string comment'设备编码'
	,operate_type     string comment'操作模式'
	,sorting_plan_codestring comment'分拣方案'
	,supply_desk_code string comment'供包台编码'
	,grid_no          string comment'格口编码'
    ,fall_time        timestamp comment'落格时间'
    ,enter_time       timestamp comment'入库时间'
    ,date_time         string comment '分区查询'
) comment '小件分拣统计明细表'
PARTITIONED BY (
  dt string COMMENT '时间分区 小时 yyyy-MM-dd-HH')
STORED AS PARQUET
LOCATION '/dw/hive/jms_dm.db/external/dm_center_sort_ass_detail_hi'
TBLPROPERTIES (
    'discover.partitions' = 'false',
    'parquet.column.index.access' = 'true'
);